Ga naar hoofdinhoud

Checking Reports

To keep Factview properly maintained, it is important to regularly verify that all financial data has been correctly mapped and processed.

Factview provides two tools for this purpose:

  • Mapping Control

  • Checklist

These tools help you verify that the financial administration has been correctly linked to the report structure.

Mapping Control​

Navigate to:

Data → Validation → Mapping Control

This opens the Control Overview.

Control Overview​

The Control Overview displays all mapped and unmapped accounts within the Dossier.

It allows you to verify that the totals from the financial administration match the report structure.

The Control Overview consists of three sections.

1. Description​

This column displays the different validation checks.

It includes items such as:

  • Total Balance of All Accounts in the Dossier

    The combined balance of all general ledger accounts in the Dossier.

  • Balance of Mapped Accounts in the Standard Structure

    The balance of all accounts that have been mapped to the report structure.

  • Calculated Import Set Difference

    The difference between the total Dossier balance and the balance of the mapped accounts.

  • Difference Caused by Unmapped or Incorrectly Mapped Accounts

    Indicates whether accounts are missing or have been mapped incorrectly.

2. Actuals by Month​

These columns display the monthly amounts for the selected financial year.

This allows you to verify that:

  • Profit and loss accounts have been mapped correctly.

  • Balance sheet accounts have been processed correctly.

  • The totals match the accounting records.

3. Total​

The Total column displays the total amount for the entire financial year.

This provides a quick way to verify that the annual totals of the Dossier match those of the report structure.

Checklist​

Another way to validate the financial administration is by using the automatic Checklist.

Navigate to:

Data → Validation → Checklist

The Checklist automatically performs a series of validation checks on the financial administration and the report structure. This allows you to quickly verify that everything has been configured correctly before creating reports.

Validation Status​

Each validation check displays a status indicator:

  • Green check mark – The validation passed successfully.

  • Red cross – An issue was detected and should be reviewed.

What Does the Checklist Verify?​

The Checklist verifies, among other things, that:

  • Import Sets are balanced.

  • All general ledger accounts have been mapped to the Standard Structure.

  • Balance sheet accounts have not been mapped to the Profit and Loss Structure.

  • Profit and Loss accounts have not been mapped to the Balance Sheet Structure.

  • Accounts have been mapped at the lowest level of the report structure.

Click Run All Checks to perform all validation checks again and update the Checklist.